﻿CREATE TABLE [dbo].[Database] (
    [DatabaseID]               INT           IDENTITY (1, 1) NOT NULL,
    [ServiceID]                INT           NOT NULL,
    [DatabaseName]             VARCHAR (200) NULL,
    [Collation]                VARCHAR (100) NULL,
    [Owner]                    VARCHAR (100) NULL,
    [RecoveryModel]            VARCHAR (20)  NULL,
    [State]                    VARCHAR (100) NULL,
    [CompatibilityLevel]       VARCHAR (50)  NULL,
    [DatabaseVersion]          VARCHAR (50)  NULL,
    [OriginalDatabaseVersion]  VARCHAR (50)  NULL,
    [CreateDate]               DATETIME      NULL,
    [LatestFullBackup]         DATETIME      NULL,
    [LatestDifferentialBackup] DATETIME      NULL,
    [LatestLogBackup]          DATETIME      NULL
);

